CREATE TABLE [acms].[Users] (
    [Id]                  INT           IDENTITY (1, 1) NOT NULL,
    [SiteId]              INT           NULL,
    [FirstName]           VARCHAR (50)  NULL,
    [LastName]            VARCHAR (50)  NULL,
    [UserName]            VARCHAR (50)  NOT NULL,
    [DateOfBirth]         DATETIME      NULL,
    [EmailAddress]        VARCHAR (100) NOT NULL,
    [EmailAuthenticated]  BIT           NOT NULL,
    [Gender]              TINYINT       NULL,
    [Address1]            VARCHAR (100) NULL,
    [Address2]            VARCHAR (100) NULL,
    [Town]                VARCHAR (50)  NULL,
    [County]              VARCHAR (50)  NULL,
    [PostCode]            VARCHAR (20)  NULL,
    [MobileTel]           VARCHAR (20)  NULL,
    [Created]             DATETIME      NOT NULL,
    [Password]            VARCHAR (255) NOT NULL,
    [Salt]                INT           NOT NULL,
    [Deleted]             BIT           NOT NULL,
    [CustomBool1]         BIT           NULL,
    [CustomBool2]         BIT           NULL,
    [CustomBool3]         BIT           NULL,
    [CustomInt1]          INT           NULL,
    [CustomInt2]          INT           NULL,
    [CustomInt3]          INT           NULL,
    [CustomString1]       VARCHAR (255) NULL,
    [CustomString2]       VARCHAR (255) NULL,
    [CustomString3]       VARCHAR (255) NULL,
    [Locked]              BIT           NOT NULL,
    [LastLogin]           DATETIME      NULL,
    [LastActivity]        DATETIME      NULL,
    [LastChangedPassword] DATETIME      NULL,
    [LastLocked]          DATETIME      NULL,
    [VersionId]           TIMESTAMP     NOT NULL
);



